----------------------------------------   ¼ DeepSoon ݿ  --------------------------
>>1̨û
Users4DeepSoon(
id int(4) not null primary key auto_increment,
name char(20) not null,
pwd char(32) not null,
class char(20) default 'super',
area char(20) ),
Email Text,
SelfIntroduction Text,
PWDAnswer char(120),
ChatHead char(200),
RegisterDate timestamp DEFAULT now(),
LastLoginDate timestamp,
Blog Text
);
̨ûһ˻˻admin룺admin888
ִ
insert into Users4DeepSoon(name,pwd) Values ("admin","7FEF6171469E80D32C0559F88B377245");
עǸַǽadmin888md5ַܺ
>>2վñ
Preference4DeepSoon(
id int(4) not null primary key auto_increment,
siteName char(20) not null,
siteTitle char(40) not null,
siteKeywords char(140) not null,
siteDescribe char(200) not null,
siteMain char(50) not null,
siteLogoAddr char(200) not null,
htmlDir char(100) not null,
uploadFileDir char(200) not null,
siteCopyRight Text,
WatermarkLogo char(200) not null,
urlRule char(200) not null
);

עǰ̨ǰñҪһ¼г
>>3־
Log4DeepSoon(
ID int(8) not null primary key auto_increment,
Name char(20) not null,
EventStr char(40) not null,
IPStr char(20) not null,
DateStr  timestamp DEFAULT now() );
>>4Ŀ¼
Class4DeepSoon(
ID int(4) not null primary key auto_increment,
Name char(20) not null,
FatherID char(20) not null,
ChildID char(250),
OutLinkHref char(150) not null,
isHidden bool default false,
ThemeFile char(250) not null default 'T_list.html',
openArea  char(20) default 'all',
linkTarget char(20) default '_self',
rootID char(20) default '0'
);
>>5±
Article4DeepSoon(
ID int(8) not null primary key auto_increment,
Title char(50) not null,
Source char(20) not null,
Author char(20) not null,
ClassID char(20) not null,
Article Text ,
TitleColor char(20) ,
setTop bool default false ,
DateStr  timestamp DEFAULT now(),
isDelete bool default false ,
BriefInfor char(150) not null,
thumbnailImage Text,
ReadCount int(8)  DEFAULT 0,
isSetIndexPic bool default false,
isPass bool default false 
);
>>6ͷͷ
HeadTitle4DeepSoon(
ID int(4) not null primary key auto_increment,
ArticleID int(8) not null);
עǰ̨ǰñҪһ¼г
>>7ӱ
Links4DeepSoon(
ID int(4) not null primary key auto_increment,
LinkName char(50) not null,
LinkHref char(200) not null,
LinkLogo char(200),
canVisit bool default true
);
>>8
AdList4DeepSoon(
ID int(4) not null primary key auto_increment,
AdContent Text,
AdPos char(100)
);
>>9վ
Theme4DeepSoon(
ID int(4) not null primary key auto_increment,
ThemeName char(100) not null
);
>>10˵˵
FeedBack4DeepSoon(
ID int(4) not null primary key auto_increment,
Content Text not null,
Author char(20),
IPAddress char(50),
DateStr  timestamp DEFAULT now(),
FatherID char(20) not null,
isPass bool default false
);
>>11˵˵ñ
FeedBackSetting4DeepSoon(
ID int(4) not null primary key auto_increment,
setTitle char(20),
setContent Text,
setButtonName char(20),
setOpen  bool default true,
setPass bool default false,
setSize int(8) default 200
);
>>12ʼñ
MailSetting4DeepSoon(
ID int(4) not null primary key auto_increment,
setTitle char(20),
setContent Text,
setButtonName char(20),
setOpen  bool default true,
Host Text,
Account Text,
PWD Text,
FromMail Text,
ToMail Text
);
>>13۱
Comment4DeepSoon(
ID int(8) not null primary key auto_increment,
Content Text not null,
Author char(20),
IPAddress char(50),
DateStr  timestamp DEFAULT now(),
FatherID char(20) not null,
isPass bool default false,
ArticleID int(8) not null
);
>>14ñ
CommentSetting4DeepSoon(
ID int(4) not null primary key auto_increment,
setOpen  bool default true,
setPass bool default false,
setSize int(8) default 200,
openArea  char(20) default 'all'
);
>>15Աñ
UserCenterSetting4DeepSoon(
ID int(4) not null primary key auto_increment,
registerOpen  bool default true,
uploadChatHeadOpen bool default true,
uploadFileOpen bool default true,
addArticleOpen bool default true
);